laaronson
New member
- Joined
- Nov 26, 2012
- Messages
- 3
- Reaction score
- 0
- Points
- 0
I am wondering if there is a way to create a custom format that would show #s rounded to the nearest 1,000th. For example, if the cell input is 345678 I want it to show as 345.7
I know i could put a formula in a different column that reads the cell with the data and then divides it by 1,000, but i'm looking for an easier way to format entire spreadsheets.
any thoughts are greatly appreciated!!
best,
laurie
I know i could put a formula in a different column that reads the cell with the data and then divides it by 1,000, but i'm looking for an easier way to format entire spreadsheets.
any thoughts are greatly appreciated!!
best,
laurie