Custom Format - or is there a way to do this?

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
 
Does this custom format work for you?

0.#,
 
Back
Top