ExcelBanter - how to stop excel from auto formatting whole number to decimal %

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how to stop excel from auto formatting whole number to decimal % (https://www.excelbanter.com/new-users-excel/128650-how-stop-excel-auto-formatting-whole-number-decimal-%25.html)

samo

how to stop excel from auto formatting whole number to decimal %

how do i stop excel from auto formatting whole numbers into decimals?

example:

input 3 -- excel would show 0.03

Ron Coderre

how to stop excel from auto formatting whole number to decimal %

Try this:

From the Excel main menu:
<tools<options<edit tab
UNcheck: Fixed decimal places

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"samo" wrote:

how do i stop excel from auto formatting whole numbers into decimals?

example:

input 3 -- excel would show 0.03

samo

how to stop excel from auto formatting whole number to decimal

ron, you are amazing!

thank you soooooo much.

"Ron Coderre" wrote:

Try this:

From the Excel main menu:
<tools<options<edit tab
UNcheck: Fixed decimal places

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"samo" wrote:

how do i stop excel from auto formatting whole numbers into decimals?

example:

input 3 -- excel would show 0.03

All times are GMT +1. The time now is 09:54 AM.