Troubleshooting

[David Rogers]

When I type a number ie. 4, when I move to another cell it becomes 0.40. I
numerous methods. It must be a setting as it repeats itself on new xls's

 

[Mike H]

Hi,

Tools|Options|Edit tab
Uncheck 'fixed decimal places'

Mike

 

[David Biddulph]

Tools/ Options/ Edit
Uncheck the entry for Fixed decimal places.